package com.yun.zf.app.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yun.zf.common.app.domain.ZfHouseInfoSale;
import com.yun.zf.common.app.dto.detail.HouseSaleInfoDto;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 房屋出售维护表 Mapper 接口
 * </p>
 *
 * @author cj
 * @since 2021-03-09
 */
@Mapper
public interface ZfHouseInfoSaleMapper extends BaseMapper<ZfHouseInfoSale> {

    @Select("<script>" +
            "SELECT hs.house_use,hs.heating,hs.owner_ship,hs.building_type,hs.build_year,hs.is_loan,hs.loan_amount " +
            " from zf_house_info_sale hs WHERE  hs.basic_id=#{basicId} and hs.city_code=#{cityCode} and hs.province_code=#{provinceCode} " +
            "</script>")
    HouseSaleInfoDto getHouseSaleInfo(Long basicId, Long provinceCode, Long cityCode);
}
